Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Can it Joined two tables like this?

3 Posts 2 Posters 0 Views 1 Watching

J Offline
J Offline
jason_mf

wrote on last edited by

#1

Table A : id name sid jid Table B: bid img sid jid select A.id,A.name,A.sid,A.jid,B.bid,B.img from A left outer join B ON A.sid=B.sid AND A.jid=B.jid I wrote sql like this. is right? "ON A.sid=B.sid AND A.jid=B.jid" is key.
K 1 Reply Last reply

0
J jason_mf

Table A : id name sid jid Table B: bid img sid jid select A.id,A.name,A.sid,A.jid,B.bid,B.img from A left outer join B ON A.sid=B.sid AND A.jid=B.jid I wrote sql like this. is right? "ON A.sid=B.sid AND A.jid=B.jid" is key.
K Offline
K Offline
Krish KP

wrote on last edited by

#2

Yes. This usage is porper, to check for multiple columns.

Regards KP
J 1 Reply Last reply

0
K Krish KP

Yes. This usage is porper, to check for multiple columns.

Regards KP
J Offline
J Offline
jason_mf

wrote on last edited by

#3

Thanks
1 Reply Last reply

0

Log in to reply