jteixeira Posted November 8, 2006 Share Posted November 8, 2006 In the same table i have in one column the hour and in the other the data. How can I join the 2 columns to apear in one hour and date? Link to comment Share on other sites More sharing options...
aspnetguy Posted November 8, 2006 Share Posted November 8, 2006 can you give us an example or some code? Link to comment Share on other sites More sharing options...
jteixeira Posted November 8, 2006 Author Share Posted November 8, 2006 Select Avarias.Maquinaid,nicname,Avarias.tipo,Avarias.Data,Avarias.horafrom Avarias INNER JOIN Maquina on maquina.maquinaid=Avarias.maquinaidGroup by Avarias.Maquinaid,nicname,Avarias.tipo,Avarias.Data,Avarias.horaOrder by Avarias.MaquinaidI Want join Avarias.Data to Avarias.hora Link to comment Share on other sites More sharing options...
pulpfiction Posted November 8, 2006 Share Posted November 8, 2006 SELECT Avarias.Data + ' ' + Avarias.hora AS Date from tlb_nameTry this.... Link to comment Share on other sites More sharing options...
aspnetguy Posted November 8, 2006 Share Posted November 8, 2006 ok try this SELECT Avarias.Maquinaid, nicname, Avarias.tipo, Avarias.Data + ', ' + Avarias.hora AS 'DateTime'FROM Avarias INNER JOIN Maquina ON maquina.maquinaid=Avarias.maquinaidGROUP BY Avarias.Maquinaid, nicname, Avarias.tipo, Avarias.Data, Avarias.horaORDER BY Avarias.Maquinaid Link to comment Share on other sites More sharing options...
justsomeguy Posted November 8, 2006 Share Posted November 8, 2006 "Date" and "DateTime" might both be reserved. You might need to use a different name like "TheDate" or something. Link to comment Share on other sites More sharing options...
pulpfiction Posted November 8, 2006 Share Posted November 8, 2006 I tried this query in SQL Server SELECT fld_1+ ' ' + fld_2 AS dateFROM tbl_nameIt did not throw any error....but like justsomeguy mentioned might throw some error.... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now