SQL Server Query problem -


I need a lot of help from you :( OK, my problem is how to prepare a query that meets my needs I have 3 tables, i.e. TableA (ColID, ColName, ColRec) , TableB (ColRec, bID) , and TableC (bid, xGrade) , XTake, ColID) .

Sample record

Enter image details here

When I search with ColID with TableA Displaying xGrade Want to TableC below:

Image Details Here Enter

but instead of the above, I get this:

Enter image details here

from bid to TableB and bid to TableC displays all records matching .

I can not end my project. Ask this question :( Please help me ..

Thanks in advance!

< Div class = "post-text" itemprop = "text"> 

  SELECT A.ColID, BBID, CACAZ from Table A. An inner job tablebie b on a. Colercake = b.clec left bbid = cdid And ACL = C on the table C. Called where A. Colled = 1   
 will it work?

Comments

Post a Comment