SQl creation problem

[Erwin007]

$query = "SELECT * FROM  `sales` WHERE rep_id = 

$query = "SELECT * FROM `reps` WHERE rep_touroperatorid = '5' 

I have difficulty explaining it but will try:
I need to select all sales where all the reps have the rep_touroperatorid 5

How to "join" or "insert into" or ??
If somebody can help, would be great.
Thanks

 

 

[Barand]

It helps us immensely if you tell us your table structures when asking about joins

[Erwin007]

Table reps:
- rep_id
- rep_name
- rep_touroperatorid

Tablse sales:
- sales_id
- sales_repid
- sales_ticketnr

 

Hope this helps
 

[Barand]

Try

SELECT rep_id
     , rep_name
     , sales_id
     , sales_ticketnr
FROM reps r
     JOIN 
     sales s ON r.rep_id = sales_rep_id
WHERE rep_touroperatorid = 5

 

[Erwin007]

Yes!
Works like a charm.
Thank you so much, learning a lot in 2 days.

😀👍

[Erwin007]

I celebrated too fast....

what exactly is "reps r",  "sales s" and r.reps_id" in:?

FROM reps r JOIN sales s ON r.rep_id = sales_rep_id

 

[Barand]

The "r" and the "s" are table aliases, not realy neccessary here (force of habit) but are useful if you have columns in different table with the same name.

Suppose reps and sales both had columns called "id"; you could then differentiate between them by either reps.id and sales.id or by using the aliases r.id and s.id, which is quicker to write.

Occasionally you may wish to reference the same table twice or more in a query in which case the alias is essential

EG

TABLE : people
------------------------------
id int primary key
name varchar
father_id int foreign key
mother_id int foreign key
------------------------------

SELECT p.id
     , p.name as person
     , f.name as father
     , m.name as mother
FROM people p
     JOIN people f ON p.father_id = f.id
     JOIN people m ON p.mother_id = m.id

 

[Erwin007]

Yes, it worked, thanks again.