how to grab the not equal row from joined table in mysql?
user3391137
i have two tables as following
user_job_applied
company_viewed_user
i want to take rows which are not in company_viewed_user table for relevant job_id in user_job_applied table. i wrote the following query for it but it's not grabbed
SELECT
`user_job_applied`.user_id
FROM
`user_job_applied`
LEFT JOIN
`company_viewed_user`
ON
`company_viewed_user`.user_id ON `company_viewed_user`.user_id = `user_job_applied`.user_id
WHERE
`company_viewed_user`.user_id IS NULL AND
`company_viewed_user`.emp_id IN (SELECT user_id
FROM company_user
WHERE company_id='1')
AND
`user_job_applied`.job_id = '1';
The output should be as following 
user3391137
want to move emp_id condition to left join statement from in where clause
SELECT
`user_job_applied`.user_id
FROM
`user_job_applied`
LEFT JOIN `company_viewed_user` ON `company_viewed_user`.user_id = `user_job_applied`.user_id AND
`company_viewed_user`.emp_id IN (SELECT user_id FROM company_user WHERE company_id='1')
WHERE
`company_viewed_user`.user_id IS NULL AND
`user_job_applied`.job_id = '1';
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
Related Related
- 1
How to find single row data from joined table in mysql?
- 2
MySQL select row with two matching joined rows from another table
- 3
Grab one row from a table
- 4
How to retrieve min price via mysql query from a joined table
- 5
How to concatenate values from joined table in specific order, mysql
- 6
MySQL LIKE from JOIN clause and GROUP_CONCAT returns only one row from joined table
- 7
Fetch Column names from a joined mysql table
- 8
Mysql - Return max value from joined table
- 9
MYSQL Query a table with a set condition and if a 2nd conidtion is met grab a row(s) from another table and continue
- 10
How to combine multiple records from a joined table
- 11
springJPA - How to read from a joined table?
- 12
Laravel 5.4 - Return single row from joined table
- 13
MySql limiting only first table from joined table
- 14
MySQL update query on a single table with value from joined table
- 15
How do I order mysql query results by values from a joined table's rows (not columns)?
- 16
How do you pull all data from a joined table when a related record contains a given value in MySQL?
- 17
MySQL averaging joined table
- 18
MySQL count on joined table
- 19
MySQL: Returning total record count from a CROSS JOINed row?
- 20
How to join only one row in joined table with postgres?
- 21
SQL Row Concatenation on joined table
- 22
getting top row of joined table
- 23
Mysql grab row if condition is met, grab another if not
- 24
Most recent distinct record from a joined MySQL table
- 25
Can't Count results from Joined Table mySQL
- 26
Use Columns From One Left Joined Table In Second Left Joined MYSQL
- 27
Grab from table values
- 28
Mysql - How to query a row from table _a that is link to table_b pointing to a different a row in table_a
- 29
Mysql - How to query a row from table _a that is link to table_b pointing to a different a row in table_a
Comments