crosstab boolean value (1 Viewer)

[sammers101]

I have 3 tables, one for customers, one for comics, one for subscriptions.
Is there a way to make a crosstab query that would show if a customer has an existing subscription or not?

The value would I guess need to be created somehow, based on if there is an entry listed in the subscription table. I have basically just started this database (expanding into selling comic books now yay ), so I can change anything I need to.

Thanks

 

[arnelgp]

you can create a single select query, to list customers with subscription:

select custid, custname, subscriptionField on customer inner join subscriptiontable on customer.custid = subscriptiontable.custid;