The main table A it A a_id field
Child table B field b_id (id), a_id table (id), val_id) (corresponding to different appearance, c_id table id (c)
Table c field c_id, tablename (table name), col (field name), showname (display name)
Table c is actually some basic file table record similar user_tables this table
Such as personnel archive table is a record 0001, table_person, person_id, person_name
I now want to find a master table data to an SQL string the three tables and other archive table? May rise up without a stored procedure or function
CodePudding user response:
Not very know what you mean?Abc3 associated query table is good, what are your other archive table table, table d? And ABC three tables have what relation?
CodePudding user response:
What's list?Use excel,
CodePudding user response:
Get some classic data, a look