A SQL query on the existence of columns in two tables

[cuqsy0]

Hi,

A SQL query on the existence of columns in two tables. For example, tables A and B have many columns, respectively, such as COLA1, COLA2, COLAM, and COLB1, COLB2, COLBN. I wish to write a SQL query to check whether Table C's columns (COLC1, COLC2, COLCL) exist in Table A and B. If possible, I prefer not to answer the question with the information_schema.columns, but use the joins/subqueries between A and B.

Thanks in advance!

-CUQ

[r035198x]

You can't do it with joins on A and B because you don't know which columns to do the joins on.information_schema is best for this. Why don't you want to use it?

[cuqsy0]

@r035198x
Thank you for the advice. How can I do it with information_schema ?