加入两个表然后在两个日期之间找到它们 [英] Join Two Tables And Then Find Record Them Between Two Dates

问题描述

我有两张桌子

优先表：AddBook

条目是：Col1（int主键自动增量），col2，col3，col4

第二张表：Book_qty

条目是：col1（foregn key），qty，Adddate

i想要加入此表，之后想要使用Adddate列搜索记录

使用条款之间

请帮帮我

先谢谢

解决方案

 从 addbook ab 
  inner   join  book_qty bq   ab.col1 = bq.col1 
 其中 adddate   ' < span class =code-string> 2012-12-12' 和 ' < span class =code-string> 2013-01-15' 

I Have Two tables
first Table:AddBook
Entries Are: Col1(int primary Key Autoincrement),col2,col3,col4
Second Table:Book_qty
Entries Are:col1(foregn key),qty,Adddate
i want to join this table and after that want to search record using "Adddate" column
using Between Clause
Please Help Me
Thank in Advance

解决方案

select * from addbook ab
inner join book_qty bq on ab.col1=bq.col1
where adddate between '2012-12-12' and '2013-01-15'

这篇关于加入两个表然后在两个日期之间找到它们的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！