• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

query 2 table and output results

Explorer ,
Nov 21, 2007 Nov 21, 2007

Copy link to clipboard

Copied

Good day,

I need to search a "client" table usign query based on a second "display" table that containd 3 rows "3 values"

So based on my display table that contained only 3 rows that match ID on my client table I need a mechanism to extract the 3 ID fields from "display" table
search and display from my "client" table.

How would I do that?


many thanks
TOPICS
Advanced techniques

Views

358

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Nov 21, 2007 Nov 21, 2007

Copy link to clipboard

Copied

I don't understand your question so I'll address the subject line

to query from two tables at the same time, this syntax will almost always work

select your_fields
from table1 t1, table2 t2
where t1.somefield = t2.something
and other_stuff

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Nov 22, 2007 Nov 22, 2007

Copy link to clipboard

Copied

LATEST
I hope join will help you as Dan mentioned.

SELECT c.* FROM client c, display d WHERE c.ID = d.ID

Thanks

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation