DebHanleyRI
Programmer
I have two tables I need to join to populate an excel spreadsheet. The following statement works, but, now I need to modify to select only distinct oldack.trans_recordid.
The oldack.date is the primary key.
Here is my select statement:
SELECT oldack.[Date], oldack.ack, oldack.visit_id, oldack.trans_recordid, transcripts.trans_three, Transcripts.Recordid, transcripts.visit_id, transcripts.transcript
FROM oldack
INNER JOIN
Transcripts ON (LTRIM(oldack.trans_recordid)) = Transcripts.Recordid
WHERE (oldack.date > "dateVariable" ) and (oldack.ack LIKE '%MSA|AE%')
Thanks,
Deb
not all who wander are lost....
The oldack.date is the primary key.
Here is my select statement:
SELECT oldack.[Date], oldack.ack, oldack.visit_id, oldack.trans_recordid, transcripts.trans_three, Transcripts.Recordid, transcripts.visit_id, transcripts.transcript
FROM oldack
INNER JOIN
Transcripts ON (LTRIM(oldack.trans_recordid)) = Transcripts.Recordid
WHERE (oldack.date > "dateVariable" ) and (oldack.ack LIKE '%MSA|AE%')
Thanks,
Deb
not all who wander are lost....