SQL, keeping 6 tables in sync

Anon

I have a database with 6 tables. All of the tables will be open at the same time displaying various information. What I am needing to do is to keep all 6 of the tables in sync. The primary key of each table is client_id. My original idea was to use a vairiable in the sql statement, ie SELECT * FROM client WHERE client_id= V (V=a variable) in each of the sql statement for each table. I did tried using various \" \' combinations to see if that would work. No go. Could someone give me proper solution to this problem, I am sure the way I am trying to do it is not the best and clearly not the proper way. Thanks

Jeff

Anon

Why would they get out of sync??? I always find that the best solution to a situation is to avoid the situation in the first place.

Anon

Hi,

I don't know your level of database knowledge, but you are joining these tables together on 'client_id' in one SQL statement, right? (I'm assuming your tables all have different types of info for each client_id and you broke it up vertically)If you don't know what I'm talking about, read up on JOINS at a relevant SQL resource.

If you broke up the table horizontally ie.(client_id 1-1000 info in one table, client_id 1001-2000 info in the second, etc...) well, don't do that. That's not necessary unless you have over a million rows at which time, you'd be using a database that could support a MERGE function.