Newb question: I executed two select statements, but I only get one table in the results. Huh?

[Adam Henderson]

Hello folks!

Please accept my abject apologies in advance if this is well documented somewhere and my searching skills have simply failed me.

I just started using Sequel Pro, but I'm familiar with many SQL IDE's - from Microsoft's to the constantly-crashing MySQLWorkBench.

When I execute two queries in Sequel Pro, like so:

SELECT * FROM table_foo;

SELECT * FROM table_bar;

What I see for results is the data only from the table_bar - nothing from table_foo.  Any ideas on how dumb I'm being?

I'm using Sequel Pro 1.1.2. on MacOS.

Thank you!

-Adam 

[Gustave Stresen-Reuter]

I believe it only shows the results form the most recent (last) statement. Perhaps in a future version it will open a new tab of results for each version???

Kind regards,

Ted

--
You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sequel-pro+unsubscribe@googlegroups.com.
To post to this group, send email to seque...@googlegroups.com.
Visit this group at https://groups.google.com/group/sequel-pro.
For more options, visit https://groups.google.com/d/optout.

[Michel Maybon]

Hello.

Use UNION.

SELECT column_name1  FROM table_foo

UNION

SELECT column_name2 FROM table_bar;

--
You received this message because you are subscribed to the Google Groups "Sequel Pro" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sequel-pro+...@googlegroups.com.