Please help me find this master can be used to achieve innerjoin
[Users questions | Browse:60 | Favorites]
Users questions: Please experts help me find this form can be achieved with innerjoin 1userinfo there username, name ftype is representative of a classification and stype and two categories (number corresponding to the proclass the classid) form 2p roclass there classid classname hope a reality show and the name of a category name, the name of the following two categories of their own expert advice wrong test results, how to achieve selectu .*, ca.classnameas' ftyp 'Cb.classnameas' styp'fromuserinfouinnerjoinproclasscaonu. Ftype = ca.classidinnerjoinproclasscbonu.sty pe = cb.classid surprised how smoothly you can run but I can not? access which I executed an invalid ~ u. * and u.username as simple as that - as to whether more than one ftype and stype show the number of out MicrosoftJETD atabaseEngine error '80040e14 'Syntax error (missing operator) in query expression' u.ftype = ca.classidinnerjoinproclasscbonu.st
Experts answer: you want to display the name, A category name, sub-category name, but the result is written u. * out of four selectu.username, ca.classnameas' ftyp ', cb.classnameas' styp'fromuserinfou innerjoinproclasscaonu.ftype=ca.classidinnerjoinproclasscbonu.stype=cb.classidscreen.width*0.35)this .width=screen.width*0.40 *
Experts answer: you want to display the name, A category name, sub-category name, but the result is written u. * out of four selectu.username, ca.classnameas' ftyp ', cb.classnameas' styp'fromuserinfou innerjoinproclasscaonu.ftype=ca.classidinnerjoinproclasscbonu.stype=cb.classidscreen.width*0.35)this .width=screen.width*0.40 *
- Jiji Ji! ! ! Find data structure answers to all the points I gave up!
- Assistance, real estate appraiser exam! Urgent! ! ! ! ! ! ! ! ! ! ! ! !
- How to separate the data Excell
- Using Oracle SQL * plus multi-table joint investigation
- the relationship between mysql and php?
- What are the dimensions of the report?
- Where to start to learn software testing
- What does it mean 100B5F27BB4040D
- How to count? ? ?
- Help write a SQL trigger ah? ? Really do not know
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.