How to filter a table with SQL command and get the result in another table?

Question

MainTable

from to cTag Signal

A B T_AtoB x_1

A B T_AtoB x_2

A B T_AtoB x_3

A B T_AtoB x_4

B A T_AtoB x_1

B A T_AtoB x_2

B A T_AtoB x_3

B A T_AtoB x_4

C F T_CtoF x_1

C F T_CtoF x_2

C F T_CtoF x_3

C F T_CtoF x_4

C F T_CtoF x_5

F C T_CtoF x_1

F C T_CtoF x_2

F C T_CtoF x_3

F C T_CtoF x_4

F C T_CtoF x_5

Hello .

How can I get other tables from the main table?

Answer 1

May compare From and To can help you:

SELECT * INTO result1 FROM main WHERE `from` < `to`;

SELECT

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **