jmac2501 Posted November 3, 2009 Share Posted November 3, 2009 Hey can i have some one check this out and see if its right? thanks Employees A_ID FirstName LastName Position Salery 1 John Wane FA1 12.00 2 Fred Clause Tester 9.00 3 Rob Myers Drive Builder 11.00 Hire B_ID DateHired Department 1 12/15/99 Warranty 2 09/09/05 Develipment 3 07/11/06 Warranty SELECT Employees.LastName, Employees.FirstName,Hire.DateHired, FROM Employees INNER JOIN Hire ON Employees.A_Id=Hire.B_Id ORDER BY Employees.LastName Output= LastName FirstName Hire Date Clause Fred 09/09/05 Myers Rob 07/11/06 Wane John 12/15/99 Thanks again. Link to comment https://forums.phpfreaks.com/topic/180154-solved-need-some-one-to-check-this-please/ Share on other sites More sharing options...
Mchl Posted November 3, 2009 Share Posted November 3, 2009 Without knowing what you want to achieve, I can only say it looks fine. [edit] Is DateHired a VARCHAR by any chance? Link to comment https://forums.phpfreaks.com/topic/180154-solved-need-some-one-to-check-this-please/#findComment-950387 Share on other sites More sharing options...
PFMaBiSmAd Posted November 3, 2009 Share Posted November 3, 2009 some one check this out That's generally the step that you would do right after you write something. Did it produce the expected results when you tried it? Link to comment https://forums.phpfreaks.com/topic/180154-solved-need-some-one-to-check-this-please/#findComment-950389 Share on other sites More sharing options...
jmac2501 Posted November 3, 2009 Author Share Posted November 3, 2009 I didn't get a change to check it without building the tables and all that. Was helping out a friend and checking his work. But if it looks good then thanks. Link to comment https://forums.phpfreaks.com/topic/180154-solved-need-some-one-to-check-this-please/#findComment-950390 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.