个人觉得你要新建一张表,也就是销售表tb_selltb_sell(sell_id,car_no,client_no)这样就可以讲汽车表和客户表联系在一起了,对一张表的插入,删除和查看你应该懂吧。要查找数据的话你可以通过表关联来找到对应的信息。比如:tb_car数据:(1,"宝马","红色","100.00") (2,"奔驰","黄色","200.00")tb_client数据:(1,"张三","12345678901","xx") (2,"李四","12345678901","xx")tb_sell数据:(1,1,1) (2,1,2) (3,2,1)SQL文:Select tb_car.*,tb_client.*From tb_sellLeft join tb_car on tb_sell.car_no = tb_car.car_noLeft join tb_client on tb_sell.client_no = tb_client.client_noWhere 1 = 1