mysql getting data from a table if it has a value in another table

Question

I have two mysql tables

myTabs

id
usercode
tab_id
fid
tablistid

Tabs

tab_id
title
usercode
access_type
question

both tables have tab_id as primary key and use the same value. I want to list the data from mytabs table which has same tab_id in Tabs Table and access_type = 1. I dont want to list the records from Tabs the query should only validate from Tabs if that Tab has access_type 1 then it should list

Is it possible? What I am trying is it has not returned anything.

 $mysql = "select  mytabs.*, tabs.* FROM mytabs, tabs  where mytabs.usercode='$usercode' and (mytabs.fid IS NULL || mytabs.fid='0') and tabs.access_type = '1' order by mytabs.tablistid asc"

Dipesh Parmar · Accepted Answer · 2013-04-27 04:42:41Z

2

You can use INNER JOIN.

select * from tabs INNER JOIN myTabs ON tabs.tab_id = myTabs.tab_id

and append other condition in where clause.

And what INNER JOIN do is return rows only when there is at least one row from both tables that matches the join condition.

edited Apr 27, 2013 at 4:42

answered Apr 27, 2013 at 4:36

Dipesh Parmar

27.3k8 gold badges65 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mudassir Hasan · Accepted Answer · 2013-04-27 04:35:55Z

1

Use this query

SELECT * FROM Shortcut s
INNER JOIN Tabs t
ON s.tab_id=t.tab_id
WHERE t.access_type=1 AND t.usercode = '$usercode'

answered Apr 27, 2013 at 4:35

Mudassir Hasan

29k21 gold badges104 silver badges135 bronze badges

Collectives™ on Stack Overflow

mysql getting data from a table if it has a value in another table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related