Hello, hope you can help again one and all. I have two tables in the same db that i need data from but it has to match. ok here it is.
my first table is named 'system', my second table is named 'burg_site'. I need to get a list from the 'cs_no' field in the table 'system' that has a field 'alt_id' that equals 'RN'.(any alt_id that = RN should give me list of all corresponding 'cs_no' entries). Now I need those cs_no entries to correspond to the cs_no entries in the table burg_site and give me info from the tables
subscribername, addresscity, addressstate, addresszip,+ order by cs_no.
cs_no(system) that has alt_id that =RN needs to = cs_no(burg_site) that corresponds to info in fields subscribername, addresscity, addressstate, addresszip all unique ,+ order by cs_no ok? thanks to one and all.
what you're looking for is called a JOIN and every basic SQL tutorial covers it
on burg_site.cs_no = system.cs_no
where system.alt_id = 'RN'
thank you for the script to my prob. Although I do understand the inner join statement, I couldn't figure out how to get rest of the information based on results from only one table(on burg_site.cs_no = system.cs_no
where system.alt_id = 'RN') though this is a simple line it was my demon..
Im still new to this so thank you again