# SQL problem: Select from multiple tables

**URL:** <https://forum.kirupa.com/t/sql-problem-select-from-multiple-tables/257111>\
**Category:** programming\
**Created:** [April 10, 2008, 10:23am UTC](https://forum.kirupa.com/t/sql-problem-select-from-multiple-tables/257111 "2008-04-10T10:23:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![encantado](https://avatars.discourse-cdn.com/v4/letter/e/bb73d2/32.png) [@encantado](https://forum.kirupa.com/u/encantado)\
**Post date:** [April 10, 2008, 10:23am UTC](https://forum.kirupa.com/t/sql-problem-select-from-multiple-tables/257111/1 "2008-04-10T10:23:57Z")

</div>

Hi all,  
I’ve got a question and hope that somebody can help me with it

**The Tables:**

Table A : Saunas

- field: id
- field: name
- field: visible

Table B : Spas

- field: id
- field: name
- field: visible

\*\*The Question:  
\*\*How do I select in 1 query every product that has visible = 1.  
So I need to display all the Saunas and all the Spas which are visible. These table are not linked with each other.

I have been trying queries like :

SELECT saunas. \* , spa\_jacuzzis. \* FROM saunas, spa\_jacuzzis  
WHERE saunas.special\_offer = ‘1’ AND spa\_jacuzzis.special\_offer = ‘1’

But it only shows me the visible saunas

Some help would be great! 😊