Reconcile 2 tables

$10-30 USD

Đã đóng

Đã đăng vào

khoảng 9 năm trước

$10-30 USD

Thanh toán khi bàn giao

I have 2 mysql tables with similar entries. i want a php code that will produce the entries present in one table but are not present in the other. This the code i have . SELECT date,bid,amount FROM finaclekenswitch WHERE (amount,ip) NOT IN (SELECT amount,ip FROM kenswitch) Its working well but the problem is where there look alike entries it wont report them as missing eg if there are 20,20,20 in one table and the other table has 20,20 the code wont report the missing 20. Which i also want it to do. Attached is the database.

Mã dự án: 7489119

Về dự án

4 đề xuất

Dự án từ xa

Hoạt động 9 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

4 freelancer chào giá trung bình $18 USD cho công việc này

@chetanghadiya007

This is Chetan Ghadiya PHP Developer at R K Infotech, Our company is highly recommended one in the field of Web Designing,Development, Software Development,Application Development like( Iphone, Android) and web hosting and SEO, we have a highly professional team and people who got with there masters degree in respective field, we put our whole heart into designing and development websites that are sure to meet our client's expectations. Thus, transforming our client's ideas and concepts into reality. Our suite of products and clients include a wide spectrum of industries: Law Firms, Ecommerce Retail/Wholesale, Online Dating, Real Estate, Informational and so on....

$10 USD trong 1 ngày