0

Hi all,
I want to do simple query to do the Join
Here is illustartion of my query which gives error

"SELECT * FROM table1, INNER JOIN table2 ON table1.colx = table2.colx LIMIT 30"

What goes wrong here?

2
Contributors
7
Replies
8
Views
7 Years
Discussion Span
Last Post by Stefano Mtangoo
0

Nope, the laptop I use is at home and I'm at work. So I will do once I get there. If you can do a test for me, I will be grateful. Otherwise I will check it at home

0

I can't check it - I don't have your DB. Guess you'll have to wait.

0

sure, but any query combining SELECT INNER JOIN and LIMIT is sufficient for my need. I want to use two different tables with related info. I don't have any other idea than using INNER JOIN....ON

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.