Hi folks I need some help!
I have two tables the first contains account information, and the second contains flags that records in the account table may have.
These are joined by the account?id. One account record may have several flags from the flag table.
ie the following select
select f.flags from flag_table f inner join account_table a on f.account_id = a.account_id where a.account_id = 4328
could result in:
I need to extract data from the account table (adresses etc) and have a column for each of the flags in the flag table and list if that particular flag is present.
Account_id, FirstName, LastName, EV1,NMI,FRH,BLO
1 Bruce Farr T F T F
(T and F could be 1 and 0)
I have been trying to get my head around this but to no avail.
Any help is greatly appreciated