I have not done a query quite like this before so could use a little help. I know the field names I am about to show are awful but I have no control over them so don't beat me up too badly.
Goal:
Find all
I know I need to inner join the table on itself via
Goal:
Find all
[Sales Register #]
where [Extened Price]
(yes that is spelled wrong, I know) matches itself in tblTicketDetails
while showing [Customer #]
to find all orders that were billed under one [Sales Register #]
then rebilled under a new one (and possibly changed customers in the process).I know I need to inner join the table on itself via
[Extened Price]
but the couple iterations I have tried have all timed out. What am I missing in this?
SQL:
SELECT tblTicketDetails.[Customer #], tblTicketDetails.[Sales Register #], tblTicketDetails.[Extened Price]
FROM tblTicketDetails AS tblTicketDetails_1 INNER JOIN tblTicketDetails ON tblTicketDetails_1.[Extened Price] = tblTicketDetails.[Extened Price];