Search results for query: *

i initially asked this in another thread, i want to make this a separate topic because i think it requires more attention, since i still cant get it to work :) HERE's the query: SELECT l.MD, l.Patient, l.SSN, l.Drug, l.LASTFILL AS [Last Fill], l.[MD Aware] AS [MD Aware?] FROM coreg AS L INNER...

SELECT l.MD, l.Patient, l.SSN, l.Drug, l.LASTFILL FROM Locallist6m AS L, blueteammds AS b WHERE l.md Like (left(b.md,4)+"*") And [md aware]=True ORDER BY l.md, l.lastfill; this is my query. when i take out blueteammds as b and expand b.md to be blueteammds.md it asks me for the value when i...

What is the difference between these? SELECT LocalList.MD, Locallist.patient, locallist.SSN, locallist.drug, locallist.Lastfill FROM Locallist, Duplicates WHERE Locallist.Patient=Duplicates.Patient ORDER BY locallist.MD, locallist.LastFill; SELECT LocalList.MD, Locallist.patient...

I'm an employee of a healthsystems organization. we have a list like follows: Dr Smoller Johnson, Gary Lipitor 10 mg 2/10/05 ... Dr Smoller Smith, Tony Lipitor 20 mg 12/10/05... Dr Smoller Robinson, Wendy Lipitor 10 mg 1/3/06... Dr Stenzo Doe, Jane Lipitor 20 mg...