Microsoft Access SQL Question these statements must work with microsoft access,
ID: 3724224 • Letter: M
Question
Microsoft Access SQL Question
these statements must work with microsoft access,
1. display the count of rows for each of the employees in Invoice followed by all its columns in Employee. Include all counts. The use of the UNION operator is not allowed
2. Display all the columns in Customer that have a corresponding relationship in Purchaser( print all of the customer id that made a purchase). A subquery connected by an IN operator must be used
cid has a relationship with pcid
eid has a relationship with ieid
inum is the invoice number
eid in employee id
pnum is the purchase invoice number
pcid is the invoice
isold. 2045 4506 4683 5043 8393 5040 504 50064 504 64423 233 9544:3 233 34606 254 3442:3 254 64423 2/16/2018 2/20/2018 $1,450.00 2/9/2018 2/17/2018 $37,040.00 2/7/2017 3/25/2017 $25,000.00 2/5/2016 3/1/2016 6,050.00 2/6/2018 2/17/2018 $34,040.00 5/7/2016 /1/2016 $5,060.00Explanation / Answer
2) SELECT column_name(s)
FROM table_name
WHERE column_name IN (Select * from t2);
As you didnt mention the table name I cant specify the query in clear