I have a left join in my select statement which works
printing all the info from tbl1 with matching info from tbl2

I also want to print true or false depending on if there is any match for each record of tbl1 in tbl2. How would I do this?

got my answer
if isnull()

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.