troubleshooting Question

SQL QUERY WITH INNER JOIN ON 3 TABLE

Avatar of alajoie
alajoieFlag for Canada asked on
Microsoft SQL ServerASP.NET Programming
5 Comments1 Solution443 ViewsLast Modified:
Hi, I need to find record on 3 tables.

Find all Record on TBL_Transaction depend on the NoStock of TBL_Car on Specified Date ( after dateout and before DateIn )

find NoStock, FirstName, LastName, Dateout, DateIn

TBL_Transaction

Field

IdTransaction  CoutoisieId   ClientID  DateOut                 DateIn
3                        2                   1            2012-01-24         2012-01-25
4                        3                   2            2012-02-25         2012-01-26

TBL_Client

Field

IdClient    LastName      FirstName
1               hamel            martin
2               hamel            steve

TBL_Car

Field

IdCourtoisie   NoStock   Marque  Model      Annee
2                     1081         toyota   corolla      2012
3                      1082         toyota   matrix      2012
ASKER CERTIFIED SOLUTION
alajoie

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros