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

Mansour_Dalir 1,676 Reputation points
2024-03-11T15:32:18.1566667+00:00

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

User's image

User's image

User's image

Hello .

How can I get other tables from the main table?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
0 comments
Accepted answer
  1. Vahid Ghafarpour 20,480 Reputation points
    2024-03-11T15:44:10.3666667+00:00

    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 **

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest