Jump to content

Can I use UNION ALL and INNER JOIN together?


johnsmith153

Recommended Posts

SELECT Name FROM table1 UNION ALL Name FROM table2 INNER JOIN etc... (requires both table1 and table 2 to be linked to table 3)

 

the sentence that you posted is wrong...  I saw also you other post... let me give you a suggestion that could help you to get answers... why you don explain exactly what you want to do (problem to solve), which are the tables involved and their structure ... only with that information people here will be able to understand your problem better and offer some insight... just MHO.

 

 

Link to comment
Share on other sites

Simple question, simple answer. Thanks Mchl, appreciate it.

 

Not sure what mikosiko is on about. How can my question be wrong? Tables, structure?? Don't be silly. You clearly looked at this, didn't understand and just assume that I have been lazy or not posted enough information. Anyone with a reasonable level of ability or higher would understand this.

Link to comment
Share on other sites

John... if you read my answer again you will realize that I did'n say that your question was wrong... specifically I said

"the sentence that you posted is wrong" ... big difference don't you think?

 

and my additional comment was only pursuing more information to help you in the best way possible.... if in addition you just read the Sticky # 2 in this forum you will see that I was asking for basically the same things.

 

 

your comments about my understanding or knowledge are totally uncalled for.  for me is a closed issue.

 

 

Link to comment
Share on other sites

You idiot. Not every post needs full detailed information. The question "how do you print out text from php?" wouldn't need someone to give details of what the text is, the answer echo $variable would be enough.

 

Question / sentence, same thing in this case.

 

You tried to give a little attitude but your PHP skills don't match the attitude. When you have top skills like one or two on here then no problem, but make sure you give it at the right time.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.