fgtsai0418 Posted July 9, 2013 Share Posted July 9, 2013 I have one master table : M,salve : Auth、User、VM include M1~M7 cloumn , have one column include "Vid"Auth have two column uid、vidV have 4 column vid+V1~V3User have : uid、pwd Now Dreamweaver can access into website link to user tableAnd now, I would like to shop M table (M1~M7 no "Vid") and V table (V1~V3 no "Vid") what can I do now...SELECT * FROM ...... Link to comment Share on other sites More sharing options...
thescientist Posted July 9, 2013 Share Posted July 9, 2013 what do you need to do, though? I'm not sure what the question is. Link to comment Share on other sites More sharing options...
fgtsai0418 Posted July 10, 2013 Author Share Posted July 10, 2013 I want to call "markers" table to php frontpage, but it should be include markers & vessel into one table. Link to comment Share on other sites More sharing options...
fgtsai0418 Posted July 10, 2013 Author Share Posted July 10, 2013 (edited) when I use this code........ Why mysql will return double value??? SELECT A.* ,B.* ,C.* ,D.* FROM markers A LEFT OUTER JOIN vessel B ON B.VID=A.VID LEFT OUTER JOIN AUTH C ON C.VID = A.VID LEFT OUTER JOIN USER D ON D.UID = C.UID Edited July 11, 2013 by fgtsai0418 Link to comment Share on other sites More sharing options...
fgtsai0418 Posted July 12, 2013 Author Share Posted July 12, 2013 case close 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