CODEWITHSUNDEEP
mysqlsql
user3313062
user3313062

Reputation: 3

How can I connect two different views in mysql query

I have two Views:

  1. vbsleads.mview_leads
    list of columns which i want to show

    • LEADDATE

    • LEADSID

    • FULLNAME

    • ADDRESS

    • SOURCENAME

    • MOBILEPHONE

    • PROBLEM

    • LEADASSIGNEDTO

  2. vbsleads.view_validaccounts
    list of columns which i want to show

    • UID

    • FIRSTNAME

I want to show above columns in single mysql query. How do I connect them?

Upvotes: 0

Views: 57

Answers (1)

Sathish
Sathish

Reputation: 4487

Try Like This

 SELECT mvl.LEADSID, mvl.LEADSID,mvl.FULLNAME,mvl.ADDRESS,mvl.HOURS_SPENT,
 mvl.SOURCENAME,mvl.MOBILEPHONE,mvl.PROBLEM,mvl.LEADASSIGNEDTO,vv.UID,
 vv.FIRSTNAME
 FROM  vbsleads.mview_leads mvl
 JOIN vbsleads.view_validaccounts vv ON (mvl.COMPANYID=vv.COMPANYID)

Upvotes: 1

Related Questions