Member Avatar for Gage84

If i wanted to select certain columns in 2 different fields would i Do

'Select "Column Name1, Column Name2 from "Table1"

INNER JOIN

"Table2"

ON

"Column Name1, Column Name2"

Obviously i'm using column name and table name as an example

so would using Inner join be appropriate, if so am I doing it right?

Also if i was to search for specific criteria s within 3 tables would I do

Select "Column Name1", "Column Name2" from "Table1"

INNER JOIN

"Table2" On
"Column1", "Column2"

INNER JOIN

"Table3"

WHERE "Column1" = 03-06-07

Thanks for any help

  • 2 Contributors
  • 1 Reply
  • 90 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by verruckt24
Member Avatar for verruckt24

Detail your query, it is very difficult to advice anything from what you have provided, give us the table designs.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.