SQL version of VLOOKUP

It looks as if you need an outer join, I’ll use a left one in my example:

select t1.Product, t1.Quantity, t2.Cost
from table1 as t1
left outer join table2 as t2
    on t1.Product = t2.Product

You can also leave out the outer keyword:

select t1.Product, t1.Quantity, t2.Cost
from table1 as t1
left join table2 as t2
    on t1.Product = t2.Product

Related Posts:

  1. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  2. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  3. SQL Inner-join with 3 tables?
  4. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  5. How can I do a FULL OUTER JOIN in MySQL?
  6. SQL update from one Table to another based on a ID match
  7. “Not unique table/alias” in MySQL
  8. Difference between JOIN and INNER JOIN
  9. What is the difference between JOIN and UNION?
  10. MySQL Multiple Joins in one query?
  11. SQL join on multiple columns in same tables
  12. 1052: Column ‘id’ in field list is ambiguous
  13. 1052: Column ‘id’ in field list is ambiguous
  14. Join vs. sub-query
  15. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  16. What’s the best way to search for a UPC code in a Database?
  17. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  18. What is the difference between UNION and UNION ALL?
  19. Selecting COUNT(*) with DISTINCT
  20. Case in Select Statement
  21. What is a stored procedure?
  22. ORA-00904: invalid identifier
  23. SQL WITH clause example [duplicate]
  24. What is an index in SQL?
  25. Inserting multiple rows in a single SQL query? [duplicate]
  26. Unknown column in ‘field list’ error on MySQL Update query
  27. Unknown column in ‘field list’ error on MySQL Update query
  28. The wait operation timed out. ASP
  29. What is SELF JOIN and when would you use it? [duplicate]
  30. The wait operation timed out. ASP
  31. Conversion failed when converting date and/or time from character string while inserting datetime
  32. Self Join to get employee manager name
  33. How do I UPDATE from a SELECT in SQL Server?
  34. SQL error “ORA-01722: invalid number”
  35. how to fix oracle ORA-01722 invalid number error
  36. SQL query to select dates between two dates
  37. MySQL – Operand should contain 1 column(s)
  38. SQL SELECT WHERE field contains words
  39. Conversion failed when converting date and/or time from character string while inserting datetime
  40. When should I use CROSS APPLY over INNER JOIN?
  41. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  42. Insert Data Into Temp Table with Query
  43. QL Error: ORA-00933: SQL command not properly ended
  44. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  45. SQL query to get the employee name and their manager name from the same table
  46. MySQL create table if not exists and insert record only if table was created
  47. error, string or binary data would be truncated when trying to insert
  48. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  49. NOT IN vs NOT EXISTS
  50. SQL SELECT WHERE field contains words
  51. Online SQL Query Syntax Checker
  52. How can I do an UPDATE statement with JOIN in SQL Server?
  53. Must declare the scalar variable
  54. ORA-00979 not a group by expression
  55. T-SQL split string
  56. ORA-00907: missing right parenthesis
  57. Join/Where with LINQ and Lambda
  58. How do I use properly CASE..WHEN in MySQL
  59. Must declare the scalar variable
  60. What is “Advanced” SQL?
  61. Rename column SQL Server 2008
  62. Why do we need “Relationships” between tables at all?
  63. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  64. Using group by on multiple columns
  65. Efficiently convert rows to columns in sql server
  66. How to turn IDENTITY_INSERT on and off using SQL Server 2008?sql-server-2008
  67. How to delete duplicate rows in SQL Server?
  68. The SQL OVER() clause – when and why is it useful?
  69. Update multiple columns in SQL
  70. Nested select statement in SQL Server
  71. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  72. Using group by on multiple columns
  73. SQL SELECT WHERE field contains words
  74. SQL Query with NOT LIKE IN
  75. MySQL query String contains
  76. How do I escape a single quote in SQL Server?
  77. What’s the difference between VARCHAR and CHAR?
  78. Cannot delete or update a parent row: a foreign key constraint fails
  79. Cannot delete or update a parent row: a foreign key constraint fails
  80. SQL Server IF EXISTS THEN 1 ELSE 2
  81. Case statement in MySQL
  82. How to update multiple columns in single update statement in DB2
  83. pandas: merge (join) two data frames on multiple columns
  84. Rename a column in MySQL
  85. T-SQL split string based on delimiter
  86. How to declare a variable in MySQL?
  87. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  88. Finding duplicate values in a SQL table
  89. ORA-01843 not a valid month- Comparing Dates
  90. Cannot delete or update a parent row: a foreign key constraint fails
  91. SQL Query with SUM with Group By
  92. MySQL Cannot Add Foreign Key Constraint
  93. How do I restore a dump file from mysqldump?
  94. Drop a temporary table if it exists
  95. How do I perform an IF…THEN in an SQL SELECT?
  96. How do I escape a single quote in SQL Server?
  97. SQL Error: ORA-00942 table or view does not exist
  98. ORA-00918: column ambiguously defined in SELECT *
  99. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  100. How Stuff and ‘For Xml Path’ work in SQL Server?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)